MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 983

View and edit SQL

Suggested facets: Object Name, Artist Nationality, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
206487 21.36.137 0 0 333831 Drawings and Prints 11 Book 97 The History of England, From the Invasion of Julius Cæsar to the Revolution in 1688           Author|Publisher|Printer|Dedicatee 983   David Hume|Robert Bowyer|Thomas Bensley|George III, King of Great Britain and Ireland British, Edinburgh, Scotland 1711–1776 Edinburgh|British, Portsmouth 1758–1834 Byfleet, Surrey|London|British, London 1738–1820 Windsor   Hume, David|Bowyer, Robert|Bensley, Thomas|George III, King of Great Britain and Ireland 17324 British, Scottish|British|British|British 746 1711 |1758 |1759 |1738 1776 |1834 |1835 |1820 1806 1806 1806 Illustrations: engraving 28942 18 1/4 x 14 3/8 x 2 3/4 in. (46.3 x 36.5 x 7cm) Jacob S. Rogers Bequest, 1921, transferred from the Library                       Books 442   Metropolitan Museum of Art, New York, NY 1
218680 1970.565.163 0 0 346187 Drawings and Prints 11 Book 97 Arbor Vitae; a book on the nature and development of imaginative design for the use of teachers handicraftsmen and others           Author|Publisher|Printer|Dedicatee 983   Godfrey Blount|J. M. Dent & Co.|Hazell, Watson, & Viney, Ltd.|James Archibald Campbell British, 1859–1937|London|British, London and Aylesbury|British, 19th century   Blount, Godfrey|Dent, J. M. & Co.|Hazell, Watson, & Viney, Ltd.|Campbell, James Archibald 22039 British|British|British|British 177 1859 |1850 |1850 1937 |1950 |1950 1899 1899 1899 Illustrations: lithography 28996 11 9/16 x 9 3/8 x 1 1/8 in. (29.3 x 23.8 x 2.9 cm) Gift of Lincoln Kirstein, 1970   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
228956 41.100.73 0 0 356601 Drawings and Prints 11 Book ; Ornament and architecture 13811 Raison d'architecture antique, extraicte de Vitruve, & autres anciens architecteurs, nouvellement traducite d'Espaignol en François, à l'utilité de ceux qui se delectent en edifices           Author|Publisher|Printer|Dedicatee 983 Written and translated by|Published by|Printed by|Dedicated to Diego de Sagredo|Gilles Gourbin|Benoist Prevost|Alonso de Fonseca y Acebedo Spanish, ca. 1490–before 1528|French, active 16th century|French, active 16th century|Spanish, 1476–1534   Sagredo, Diego de|Gourbin, Gilles|Prevost, Benoist|de Fonseca y Acebedo, Alonso Don 29385 Spanish|French|French|Spanish 2198 1490 |1500 |1500 |1476 1528 |1599 |1600 |1534 1555 1555 1555 Printed book with woodcut illustrations 33727 Overall: 8 1/16 x 6 1/2 x 9/16 in. (20.4 x 16.5 x 1.5 cm) Bequest of W. Gedney Beatty, 1941   Paris 27                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
231589 1979.641 0 0 359328 Drawings and Prints 11 Book 97 A Display of Heraldrie: Manifesting A more easie accesse to the knowledge thereof that hath beene hitherto published by any, through the benefit of Method; Whereinto it is now reduced by the study and industry Of John Gvuillim, late Pursuivant at Armes           Author|Publisher|Printer|Dedicatee 983   John Guillim|Jacob Blome|Thomas Cotes|Thomas Howard British, 1550–1621|London|British, died 1641|British, Finchingfield, Essex 1585–1646 Padua, Italy   Guillim, John|Blome, Jacob|Cotes, Thomas|Howard, Thomas 30925 British|British|British|British 177 1550 |1600 |1541 |1585 1621 |1699 |1641 |1646 1638 1638 1638 Illustrations: woodcut 33876 11 1/4 x 8 x 1 5/8 in. (28.6 x 20.3 x 4.1 cm) Gift of Charles K. Wilkinson, 1979                       Books 442   Metropolitan Museum of Art, New York, NY 1
245445 41.100.124 0 0 373659 Drawings and Prints 11 Book ; Ornament and architecture 13811 Lexicon de partibus aedium Francisci Marii Grapaldi parmensis           Author|Publisher|Printer|Dedicatee 983   Francesco Mario Grapaldi|Haeredes Simonis Vincentii|Melchior and Gaspar Trechsel|Orlando Pallavicino Italian, 1465–1515|Italian   Grapaldi, Francesco Mario|Haeredes Simonis Vincentii|Trechsel, Melchior and Gaspar|Pallavicino, Orlando 34514 Italian|French|French|Italian 2757 1465 1515 1535 1535 1535 Printed book with woodcut illustrations 33727 Overall: 6 5/8 x 4 1/2 x 1 in. (16.9 x 11.5 x 2.6 cm) Bequest of W. Gedney Beatty, 1941   Lyon 312                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 130.477ms · Data license: CC0 · Data source: metmuseum/openaccess